Formula Editor

Use the Formula Editor to create and edit formulas. The Formula Editor contains four main windows.

Window	Description of contents
Report Fields	Report fields contain all database fields accessible for your report. They also contain any formulas or groups already created for the report.
Functions	Functions are prebuilt procedures that return values. They perform calculations such as average, sum, count, sin, trim, and uppercase.
Operators	Operators are the "action verbs" you use in formulas. They describe an operation or an action to take place between two or more values. Examples of operators: add, subtract, less than, and greater than.
Formula text window	Area where you create or edit a formula.

Note:    Changing the syntax from Crystal syntax to Basic syntax or vice versa will change the list of functions in the Functions window as well as the list of operators in the Operators window. The functions and operators differ from syntax to syntax.

Create a formula by double-clicking on any of the components listed in the Report Fields, Functions, or Operators trees. When you choose a component, the required syntax is also inserted. You can also manually enter a formula.

When you are finished creating or editing a formula, click Check to identify any errors in the formula and click Save and Close to save the formula and return to your report.

Related topics

Creating a formula and inserting it into a report

Formula Editor buttons

Formula syntax

Operators

Functions

Using Formulas

Formulas In Action